Digital procurement transformation on a budget

For years, I managed project-based procurement in an engineering company using nothing but Excel and email. We supplied lighting equipment for Olympic ski slopes, shopping malls, bridges, and business centers—all without an ERP or any specialized procurement system. It was fast-paced, high-stakes work, and looking back, I can see just how much time and clarity we lost to manual chaos.

But here's the good news: you don’t need an ERP to transform procurement. With smart, affordable tools like Google Sheets, n8n, and ChatGPT, it’s possible to automate routine tasks, improve transparency, and reduce delays—all on a budget.

Our reality: Procurement without a system

At LUMINAR-Engineering, every project was unique. There was no warehouse; all materials were ordered per project and delivered directly to the site—often across international borders and under tight construction timelines. Our procurement workflow looked like this:

• Sales/engineering teams emailed me equipment specs split into Excel files—often 7-10 per project.
• I emailed RFQs manually to each vendor, often repeating the same data in slightly varied formats.
• Vendor responses arrived in dozens of scattered emails.
• I updated a massive Excel file to track every deadline, shipment, and approval.
• Delivery statuses were pulled from emails and entered by hand.

This process may sound familiar to many small or mid-sized procurement teams. It’s flexible, fast to set up, and doesn’t require upfront investment. But it comes with major drawbacks:

• Single-person dependency: Only I understood the spreadsheet. If I went on vacation or got sick, someone had to retrace every step.
• Lack of transparency: Stakeholders had to ask me for every update. No one had a real-time view of order status, which led to delays and miscommunication.
• Missed follow-ups: With no reminders, a delayed vendor response could slip through the cracks.

We did our best, but as the number of projects grew, so did the stress. Bottlenecks were common. Information got lost and orders faced the potential of delays. What we needed wasn’t just more people—we needed smarter systems.

Rethinking procurement: A smarter way

We didn’t need an ERP. We needed visibility, automation, and consistency—things that can now be built with low-code tools. And this shift doesn’t require massive restructuring. It starts by replacing just one weak link in the chain—such as quote requests or deadline tracking—and expanding from there.

Here’s how I would redesign that same process today using what I’ve learned since:

1. Automating RFQs with n8n

Instead of manually emailing 10 vendors for quotes, I’d build a simple RFQ workflow in n8n, a no-code automation tool. You can connect a Google Sheet or Airtable base that holds project and vendor data. When a new RFQ entry is added, n8n can:

• Send templated RFQ emails to multiple vendors at once
• Wait for replies and log them in a unified sheet or form
• Automatically send reminders if responses are late
• Track the date, pricing, and terms submitted by each vendor

This alone would save hours of repetitive work and bring RFQ visibility to the whole team. It also ensures consistency—every vendor gets the same format, every time. And the results are instantly viewable by team leads or managers.

2. Use Airtable for centralized tracking

Replace the massive Excel tracker with Airtable—a cloud-based, team-friendly database. Each order becomes a record with linked fields: supplier, status, estimated delivery, project number, contract details, and communication logs. Airtable allows you to:

• Filter by project, supplier, or delivery date
• Share views with stakeholders without exposing sensitive data
• Build a visual dashboard to track KPIs such as RFQ response rate, average delivery time, and overdue items

Even better—it’s collaborative. Everyone on the team can see real-time updates, not just the spreadsheet’s author.

3. Deadline alerts and status bots

With tools like n8n, Slack, or Telegram, it’s easy to set up smart alerts and reminders:

• “Reminder: Siemens shipment is due in 3 days.”
• “Action needed: No response from Vendor X after 5 days.”

Now, delays can be spotted early—and escalated before they become a crisis. These reminders can even be customized by role—for instance, only notifying logistics staff when customs documentation is delayed. This targeted alerting saves time and prevents inbox overload.

4. Smart assistance with ChatGPT

When I receive a 100-line quote from a vendor, instead of scanning it line by line, I can now ask ChatGPT:

“Where are the most expensive items? Where can I negotiate?”

Or feed it a contract draft and ask:

“Highlight any unusual payment terms.”

It’s not perfect—but it’s fast, cheap, and surprisingly effective. ChatGPT also helps draft supplier communications, analyze pricing discrepancies, and prepare summaries—especially useful when juggling multiple projects.

I've even used ChatGPT to brainstorm cost-saving strategies for a complex lighting order or generate questions to ask a vendor during a negotiation.

Combining tools into a modular procurement stack

One of the biggest benefits of using modular tools is flexibility. Each tool can be added when needed, and they can work together. For example:

• Google forms or Typeform for internal purchase requests
• Airtable as a procurement database and live dashboard
• n8n as the logic engine behind notifications, status updates, and data syncing
• ChatGPT as a smart assistant

You can even connect email parsing into the workflow—have incoming vendor emails automatically logged or categorized. Or build simple self-service dashboards where team members can check order statuses without asking procurement.

Expanding gradually—without ERP overhead

What’s powerful about this setup is that it scales gradually. You don’t need a six-month ERP rollout or IT support to get started. Begin with:

• One automated RFQ template
• One shared tracker in Airtable
• One Slack alert workflow for late shipments

Then, build from there. If needed, tools like Kissflow Procurement Cloud, Procurify, or Precoro offer more structure—they’re lightweight SaaS tools built for non-ERP teams. These platforms can add budgeting, approvals, and supplier management without requiring deep technical skills.

Even general tools like Monday.com or Asana, when paired with the right plugins, can serve as surprisingly robust procurement tracking hubs.

Why this matters—especially for project-based teams

Procurement in project-driven environments is inherently different from MRO or retail procurement. Timelines are tighter, coordination more complex, and the margin for error smaller. A delayed shipment doesn’t just impact a task, it can delay construction, installation, or certification.

That’s why project procurement teams need tools that are:

• Responsive and update in real time
• Customizable and tailored to each project or workflow
• Lightweight with no need for months-long integration

With no-code and AI tools, even small teams can operate with structure, speed, and foresight.

If I could redo it all again, I’d start small: one automated RFQ, one shared tracker, one alert bot. These small wins add up fast and create immediate impact.

Digital transformation doesn’t have to be big and expensive. With a handful of smart tools and a bit of experimentation, even small procurement teams can unlock serious value—faster cycle times, fewer delays, clearer communication.

And perhaps most importantly: the team is empowered, not burdened. People focus less on searching inboxes and more on strategy, supplier relationships, and quality control.

About the author

Kseniia Litovskaia is a procurement professional with 10+ years of experience managing complex project-based sourcing in engineering and lighting construction. She is currently pursuing a BBA in California and focuses on digital transformation in procurement for small teams.

SC
MR